package sky.service.ServiceImpl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import sky.common.CustomException;
import sky.dto.SetmealDto;
import sky.mapper.SetmealMapper;
import sky.pojo.Category;
import sky.pojo.Setmeal;
import sky.pojo.SetmealDish;
import sky.service.CategoryService;
import sky.service.SetmealDishService;
import sky.service.SetmealService;

import java.util.List;
import java.util.stream.Collectors;


@Service
public class SetmealServiceImpl extends ServiceImpl<SetmealMapper, Setmeal> implements SetmealService {


    @Autowired
    private SetmealService setmealService;

    @Autowired
    private CategoryService categoryService;

    @Autowired
    private SetmealDishService setmealDishService;


    /**
     * 修改套餐时套餐的回显
     *
     * @param id
     * @return
     */
    @Override
    public SetmealDto getByIdWithDish(Long id) {

        SetmealDto setmealDto = new SetmealDto();
        //先查询setmeal中的数据
        Setmeal setmeal = setmealService.getById(id);

        //将数据拷贝
        BeanUtils.copyProperties(setmeal, setmealDto);

        //查询category中的数据
        Category category = categoryService.getById(setmeal.getCategoryId());

        setmealDto.setCategoryName(category.getName());

        LambdaQueryWrapper<SetmealDish> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.eq(SetmealDish::getSetmealId, id);

        List<SetmealDish> list = setmealDishService.list(lambdaQueryWrapper);

        setmealDto.setSetmealDishes(list);
        return setmealDto;
    }


    /**
     * 新增套餐，同时需要保存套餐和菜品的关联关系
     *
     * @param setmealDto
     */
    @Override
    @Transactional
    public void saveWithDish(SetmealDto setmealDto) {
        //保存套餐的基本信息，操作setmeal，执行insert操作
        this.save(setmealDto);

        List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();
        setmealDishes.stream().map((item) -> {
            item.setSetmealId(setmealDto.getId());
            return item;
        }).collect(Collectors.toList());

        //保存套餐和菜品的关联信息，操作setmeal_dish,执行insert操作
        setmealDishService.saveBatch(setmealDishes);
    }

    /**
     * 删除套餐，同时需要删除套餐和菜品的关联数据
     *
     * @param ids
     */
    @Override
    @Transactional
    public void removeWithDish(List<Long> ids) {
        //select count(*) from setmeal where id in (1,2,3) and status = 1
        //查询套餐状态，确定是否可用删除
        LambdaQueryWrapper<Setmeal> queryWrapper = new LambdaQueryWrapper();
        queryWrapper.in(Setmeal::getId, ids);
        queryWrapper.eq(Setmeal::getStatus, 1);

        int count = this.count(queryWrapper);
        if (count > 0) {
            //如果不能删除，抛出一个业务异常
            throw new CustomException("套餐正在售卖中，不能删除");
        }

        //如果可以删除，先删除套餐表中的数据---setmeal
        this.removeByIds(ids);

        //delete from setmeal_dish where setmeal_id in (1,2,3)
        LambdaQueryWrapper<SetmealDish> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.in(SetmealDish::getSetmealId, ids);
        //删除关系表中的数据----setmeal_dish
        setmealDishService.remove(lambdaQueryWrapper);
    }


    /**
     * 修改套餐，同时需要修改套餐和菜品的关联数据
     * @param setmealDto
     */
    @Override
    @Transactional
    public void UpdateWithDish(SetmealDto setmealDto) {

            // 保存setmeal表中的基本数据。
            this.updateById(setmealDto);

            // 先删除原来的套餐所对应的菜品数据。
            LambdaQueryWrapper<SetmealDish> queryWrapper = new LambdaQueryWrapper<>();

            queryWrapper.eq(SetmealDish::getSetmealId, setmealDto.getId());
            setmealDishService.remove(queryWrapper);

            // 更新套餐关联菜品信息。setmeal_dish表。
            // Field 'setmeal_id' doesn't have a default value] with root cause
            // 所以需要处理setmeal_id字段。
            // 先获得套餐所对应的菜品集合。
            List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();

            //每一个item为SetmealDish对象。
            setmealDishes = setmealDishes.stream().map((item) -> {

                //设置setmeal_id字段。
                item.setSetmealId(setmealDto.getId());
                return item;
            }).collect(Collectors.toList());

            // 重新保存套餐对应菜品数据
            setmealDishService.saveBatch(setmealDishes);


              /* //修改setmeal表
        this.updateById(setmealDto);

        List<SetmealDish> setmealDishes = setmealDto.getSetmealDishes();

       setmealDishService.updateBatchById(setmealDishes);

        //修改category表
        Category category = categoryService.getById(setmealDto.getCategoryId());
        category.setName(setmealDto.getCategoryName());
        categoryService.updateById(category);*/
    }
}